UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99V9hkQD3zia75xOEzLY4wJvQhFGg1EEVBsy69GsVTE='
WHERE
key_id = 'f5c420cd707e629a19ab898d5e553754e85ffa1798beb711eaf70366139cd577'
AND (
token = '99V9hkQD3zia75xOEzLY4wJvQhFGg1EEVBsy69GsVTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)