Roscommon snatch comeback win in Salthill thriller