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

Query time 0.00023