UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJgU9YTlhyECRRKZ2S+BJScbTMzUYfA7/+29d7vJlR4='
WHERE
key_id = 'eb4e83848680d88d8c76bed635b0e7c18c87504c77043a7808663ec4fde3367a'
AND (
token = 'zJgU9YTlhyECRRKZ2S+BJScbTMzUYfA7/+29d7vJlR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)