UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MLh4yKv/tVXjk6rVhIFGbTo7xBPlUYpXEFky4WsqJxQ='
WHERE
key_id = 'e8e236163adba1ed683b8a97d0d76721bbd1751d88e807816beaa742f9efefe9'
AND (
token = 'MLh4yKv/tVXjk6rVhIFGbTo7xBPlUYpXEFky4WsqJxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)