Magento 2.3.3 customer password update after customer login not working

I have customer password change using this way and password change successfully

after i am login customer then login is not working below type error showing

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE `customer_entity` SET `failures_num` = ?, `first_failure` = ?, `lock_expires` = ? WHERE (entity_id = '20377')

customer login 1205 Lock wait timeout exceeded; try restarting transaction,

After i have also truncate customer_visitor table and restart mysql server but still no luck for me

then i am login customer and it’s going 504 Gateway Timeout