txn: fix issue innodb_lock_wait_timeout doesn't work in some case (#56847)

txn: fix issue innodb_lock_wait_timeout doesn't work in some case (#56847) #15289