UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZGM78MObjrThgH0NoRnfUvrfyVtyQzkB0krcETENog='
WHERE
key_id = 'cfd8fd0dfa0988002a78708764caa836931cb2e93bce7403ce56b63cbc61d7eb'
AND (
token = 'ZZGM78MObjrThgH0NoRnfUvrfyVtyQzkB0krcETENog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)