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