UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C2KItCwt98z5Dy7o2LWLUku0AH7l7HxbwdBnT8BP2yA=' 
WHERE 
  key_id = '6c53d9c0fa4432ea8aa05ec588d3be33e29ed86db63df0b2899bd5a33b7dffe0' 
  AND (
    token = 'C2KItCwt98z5Dy7o2LWLUku0AH7l7HxbwdBnT8BP2yA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035