UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yu7h3+b4l4vKWyeJgun+wfeVdrVYooQsfQ+V08+9Tro='
WHERE
key_id = 'f0906f6606bbf760a36e07ce721229f3f01e8d4249c7df2ced763ae13cd607cc'
AND (
token = 'Yu7h3+b4l4vKWyeJgun+wfeVdrVYooQsfQ+V08+9Tro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)