Police are appealing for witnesses after a 48-year-old man died in a car crash in Rotherham.