Set "lock wait timeout" in MySQL 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.