T-SQL trigger to update columns
Here is the problem:

You update the table
It triggers the update trigger: updateInvisibility
In the trigger you update the table again so it triggers the updateInvisibility trigger

and then it keeps doing that so you end up triggering the trigger many times in a sort of recursive fashion without even realizing. SQL server will allow this call nesting to be 32 levels deep and then it throws this error:

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

which is pretty clear.
T-SQL Solution
The code-only solution is to check the nesting level and leave if bigger than 1 (1 is the first time it is called by the update):
IF TRIGGER_NESTLEVEL() &gt; 1 RETURN;

Like this:
ALTER TRIGGER [dbo].[updateInvisibility]
ON [dbo].[table]
AFTER UPDATE
AS
BEGIN
    IF TRIGGER_NESTLEVEL() &gt; 1 RETURN;

    -- Do your work...
END

Alternative
As pointed out in a comment by RBarryYoung, you can prevent this problem in the first place by disabling recursive triggers.