UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CbEcpJwHMR0pT+j2UOrLqDZaw2NSBj0nPKqc0BSRRDg='
WHERE
key_id = 'c3196efaf54aa5954e864268fedfc1c5e4b6d153620e635a286e2576bb78edf3'
AND (
token = 'CbEcpJwHMR0pT+j2UOrLqDZaw2NSBj0nPKqc0BSRRDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)