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