UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eEjb8MEw6qpgtm3L0yVR06vbl79mau/QZLdgnOG7ewI=' 
WHERE 
  key_id = '62bfb7d49801c7a60e5e2d61ed611d73f48b9331555b7e4da877fc2fcfa3cc9e' 
  AND (
    token = 'eEjb8MEw6qpgtm3L0yVR06vbl79mau/QZLdgnOG7ewI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022