UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fSG/JZ7DFy1/fCO+QTMwi4vtoxMTqcmIArw4niy3r+U='
WHERE
key_id = '31f975ef0cfbb26b9872897801f6bea644aac332e770ba2fbef4f8b12db868ae'
AND (
token = 'fSG/JZ7DFy1/fCO+QTMwi4vtoxMTqcmIArw4niy3r+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)