UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YyDDCFJZ+HGvO6VIavPuni/7pK0YTGg1WTNlYmdUoOw='
WHERE
key_id = 'a75112d879abf0bd95501a78c87f34dcd87327395c61ad8748aa35a0e52a7904'
AND (
token = 'YyDDCFJZ+HGvO6VIavPuni/7pK0YTGg1WTNlYmdUoOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)