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