Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
By default, it is 50 seconds
Just set innodb_lock_wait_timeout as needed.
If you hit the 50-sec InnoDB timeout, you have a poorly designed application!
That timeout exists to catch naughty things that cannot be caught any other way.