UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7x3L0Ti3pv5iMxY8m/ZtEonsptq44w4Sm8bS1DsfvxY=' 
WHERE 
  key_id = '3e93c6aa8e38ac094e7b38bcad4338dccda420cda2268bb889e79ebe60a3cf96' 
  AND (
    token = '7x3L0Ti3pv5iMxY8m/ZtEonsptq44w4Sm8bS1DsfvxY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044