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