а так:
UPDATE table SET ...... WHERE ips='$ip' ORDER BY id DESC LIMIT 1