UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZBzGHm4cJl/9krgBRSHtw8pHECUWc6D9VIaB2H/oB4='
WHERE
key_id = '4ca249ef982f7ba4bbe01ba15185cde3fe80b90ce14a842b5ff1c4a8177b8d26'
AND (
token = 'fZBzGHm4cJl/9krgBRSHtw8pHECUWc6D9VIaB2H/oB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)