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