UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRlINI6+50he/PqYVv+nmYNfrOf2cDc2P06Rh3Gyf4M='
WHERE
key_id = 'bf74c446d4b3fb9880595f80f1befc7c6c8e8f731519e7b72503ee03c32e3570'
AND (
token = 'KRlINI6+50he/PqYVv+nmYNfrOf2cDc2P06Rh3Gyf4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)