UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmZq5Vwkstg4SbN/QF5IecLMoZFA5LGKDNucj6jppWw='
WHERE
key_id = '4ce037c52295fb848653c3a47ea48f1500333f3ef1d8accf91aa47db8aeadc52'
AND (
token = 'LmZq5Vwkstg4SbN/QF5IecLMoZFA5LGKDNucj6jppWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)