UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'POtK9+m+IBLZa4eBwaZjSRy9aXxszRXTTgW9thiFIes='
WHERE
key_id = '642fe567478662be3f59a842b41d45f54951f99006effae7303c7e0a26febec0'
AND (
token = 'POtK9+m+IBLZa4eBwaZjSRy9aXxszRXTTgW9thiFIes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)