UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2qvBhoLa7C3ZX5NKwrqizsxAuNL0oRy5TmQlR+I3BCc=' 
WHERE 
  key_id = 'e9bcce926b2572ab6a3c0c8a6556a5683a8acb611be8be0d19aa85b882534d21' 
  AND (
    token = '2qvBhoLa7C3ZX5NKwrqizsxAuNL0oRy5TmQlR+I3BCc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )