There's no single answer, because the airline sets how long an unpaid reservation is held, not the embassy and not the agent who made it. What you can control is timing.
Why expiry matters to embassies
Checklists increasingly say the booking must still be live:
- German Embassy Cairo: "an existing, valid flight reservation".
- German Embassy Nairobi: "Cancelled reservations will not be accepted" (for accommodation).
- German missions in Saudi Arabia: hotel bookings "might be verified" and cancelled ones lead to denial.
A reservation that has lapsed by the time an officer looks at it can look like a cancelled one.
How to time it
- Get the reservation close to your appointment or submission date, not weeks before.
- Check it with the airline using the PNR just before you submit (how).
- If your appointment moves, ask for new dates rather than submitting an old booking.
After the visa is granted
The Spanish consulate in Edinburgh warns that "Modification or cancelation of any travel reservation after the Visa is granted may lead to refusal in future Visa applications." Travel on the plan you submitted, or book the real ticket to match it.