UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZQvt9g4VQ1crPU1khBAdolsqmg+dhUr9/r6wQ5EsULg=' 
WHERE 
  key_id = '18e3398a75adeaaa74946c4c04d2648f64352838d4320555c3d9263c4a896581' 
  AND (
    token = 'ZQvt9g4VQ1crPU1khBAdolsqmg+dhUr9/r6wQ5EsULg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020