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