Casting binary(16) to a bigint will truncate it. bigint only has 8 bytes of storage.

You must convert both the first and second sets of 8 bytes to a bigint...