Paul Mooney was killed on Monday evening when the car he was a passenger in was involved in a two-car collision