I'm getting the same error:
SQL Error: Duplicate entry '6-4' for key 1
I've tried this:
UPDATE ubbt_USER_GROUPS SET GROUP_ID = '4' WHERE GROUP_ID = '5' AND USER_ID > '1'
and this:
UPDATE ubbt_USER_GROUPS SET GROUP_ID = '4' WHERE GROUP_ID = '5' AND USER_ID > 1
and get the same error.