Actually i have foudn what the error was:

UPDATE does nto work LIKE INSERT

cur.execute('''UPDATE visitors SET a=1, b=2, c=3 .... , WHERE host LIKE %s''',

each column need to be mentioned on its own and not as i had typed it which was similar lokking t INSERT.