UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pvcDESN18WhL00xPcWYAE7fhTIgY+C23ofCVLJwhuSs=' 
WHERE 
  key_id = '0d85b42a364dfe6e35463c9a8680e2e9e5aba444527fc36b4c35d6c11f5c8202' 
  AND (
    token = 'pvcDESN18WhL00xPcWYAE7fhTIgY+C23ofCVLJwhuSs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022