UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czVp4vzpqHHg2RLzMPi1ampLCjIm+xDNyDuLrZVz01w='
WHERE
key_id = '8bceb53d33aa78e4f1fa82a360ae4e0884fcf7940166f8f0114188a70839599e'
AND (
token = 'czVp4vzpqHHg2RLzMPi1ampLCjIm+xDNyDuLrZVz01w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)