UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'spsZ/GYn3imqZ+fd7Ctaci86LDhF4D29mD99fXJRA5k='
WHERE
key_id = 'd32e349b2ee99417417252a54304987d53ede5f3bac6cc48179e698381b64b0f'
AND (
token = 'spsZ/GYn3imqZ+fd7Ctaci86LDhF4D29mD99fXJRA5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)