Tidal dynamics in the sand motor lagoon