A 42-year-old man has been shot in a carpark north of Brisbane, leaving him with serious injuries.