UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCmISuxxZUlE1uqcRFWkNWoQS+/JAxkIN+pew+Hi12c='
WHERE
key_id = 'afb46d5aa0c32d5d5ce8652108a2b6ecc458090e5f3573b0fbbf3a5b03321543'
AND (
token = 'nCmISuxxZUlE1uqcRFWkNWoQS+/JAxkIN+pew+Hi12c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)