UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NjESZMdSFBtyze6gA3Fkwik+POAQIfT5FYP9oG+awQE='
WHERE
key_id = 'aaa49390bbb943d91fbc5bfaf05daec7c7452d91352e02f857f761e7227449d1'
AND (
token = 'NjESZMdSFBtyze6gA3Fkwik+POAQIfT5FYP9oG+awQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)