A man in his 30s died at the scene after a blue Yamaha off-road motorbike collided with a barrier used to close a car park