Revisiting the Boundary Conditions for Unsteady Flows Adjacent to Rigid and Dynamic Solid Walls