UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXqIMBCTF5re3qGIiIKZGtzgUwaM6inyW1u1V6AVYn4='
WHERE
key_id = 'fd434d7658819a3ec8d608a60d22fd05dfc723d7924f731f3860f79e8e0bed15'
AND (
token = 'uXqIMBCTF5re3qGIiIKZGtzgUwaM6inyW1u1V6AVYn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)