UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gXvMwym8mKtkW6kCMZMFslI0rWqiFkxncS5HYOpViw='
WHERE
key_id = 'd2f48fa177ed66392137ffcde7f57d241ff435b3e93157f9f38017243cb345bf'
AND (
token = '6gXvMwym8mKtkW6kCMZMFslI0rWqiFkxncS5HYOpViw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)