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