After 40 days, the US government shutdown appears close to ending as several Senate Democrats backed a Republican deal, sparking internal party tensions.