The buffs act like the classic ship buffs in that they cannot be dispelled, persist though rest, disappear on death/leaving quest, and have a 1-hour duration. Clicking the altar buffs your character and hirelings if they are ordered to use it. The quests feature randomly spawning mysterious altars.