Mysql错误：尝试获取锁定时发现死锁

I keep getting the deadlock error - Mysql error: Deadlock found when trying to get lock when updating products.

I did not write the sql statement and to me it's a mess. Writing a new app but need to fix this until then. I added - INTERVAL 900 SECOND order by id. The deadlock doesn't appear but now it doesn't update the products. Can someone show a better solution or show me why it's not updating?

$sql = "UPDATE  `"