Queensland police investigate the suspicious death of a man in his 40s who was found with critical injuries north of Brisbane overnight.