UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z00GYMwkqqdURB/Rn/pFfmwguqAj8nwkjGjKlctn1qg='
WHERE
key_id = '02fd5b9adc8977de312cfd8190e64f1dd492271ca6dbf59707e86a3b7d5ee8a5'
AND (
token = 'z00GYMwkqqdURB/Rn/pFfmwguqAj8nwkjGjKlctn1qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)