UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'p1V7lIg7/ieXP1R5PZtqUzx80K/ra1zCVDWOgOD7pGM=' 
WHERE 
  key_id = '7c7b1e0b314dbb6d789af5a215f0c155aa5f17c4890e0fa2cd1aa8f69436b6b9' 
  AND (
    token = 'p1V7lIg7/ieXP1R5PZtqUzx80K/ra1zCVDWOgOD7pGM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029