UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B2TK0imk4vdK4Dabk37m9Q1TEcMkdawrQIOSL7mwOPU=' 
WHERE 
  key_id = '2eab0d235e451e4fc426d3d9d2e8df0c9262587103595ac0f3d92b336ab989a3' 
  AND (
    token = 'B2TK0imk4vdK4Dabk37m9Q1TEcMkdawrQIOSL7mwOPU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033