Union members at Molson Breweries have voted in favour of a new seven-year collective agreement.