The 31-year-old pop star - who previously got sober in 2014 - appeared dazed as he clutched a bottle of Clase Azul Mxico tequila in the middle of a packed crowd of partygoers