UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJvSCoZpIg/ueeZ6uYvVxwQfhNDl2vPW0m/o08P7Rws='
WHERE
key_id = 'f3a8a5feae5b50e9ac8bdfb8f597da0f9ff0f028367e26b2262744ca26394dce'
AND (
token = 'yJvSCoZpIg/ueeZ6uYvVxwQfhNDl2vPW0m/o08P7Rws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)