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