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