UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2hKlpkwa8RX6X79WpWQhbzY0T25dkbWOt1y0vbn0AsI=' 
WHERE 
  key_id = '52c1a1e7ea9daafbd8ddb8a8fac2f7b442304589a2a5716f06caf32b15aa0d0e' 
  AND (
    token = '2hKlpkwa8RX6X79WpWQhbzY0T25dkbWOt1y0vbn0AsI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )